Number formatting decimal "." instead of "," and NO "1000 - seperator"

Hello everyone,

Standard EXCEL is configured to show numbers as follows: 132.546,256

(hundred and thirty two thousand five hundred and fourty six AND two hundred and fifty six thousands)


Just in one file I need formatting to be as follows: 132546.256.

So decimal values noted with periods . and not kommas ,.

Through adapted cell properties I dont get there.

To change the standard configuration of EXCEL is no option as it would change the formatting of ALL my files, which I dont want.

It is about an application whereby cordinates in QGIS (Software for a  Geografical  Information Syseem) are copied and pasted into EXCEL.
QGIS Works with the American formatting ("." instead of ","). Then I need to re-upload the file again to a site working with the American system.

A workaround could be to create a new user on the PC and to use in this configuration EXCEL without the 1000-separator and a period (.) as a decimal separator.

But thats not really a work friendly solution as most of my work is done in the European system, i.e. "," for decimal numbers.

Thank you for a clear and superb solution!

April 2nd, 2015 3:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics